package htlgkr.nodlehs;

public class DBRoomsTbl implements DBRoomsColumns{
	public static final String TABLE_NAME = "rooms";
	public static final String SQL_DROP = "DROP TABLE IF EXISTS rooms";
	public static final String SQL_DEL = "DELETE rooms";
	public static final String[] ALL_COLUMNS = new String[] { roo_ID + " AS _id", roo_name, roo_floor, roo_note};
	public static final String SQL_CREATE = "CREATE TABLE rooms ( " +
			"roo_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, " +
			"roo_name TEXT NOT NULL," +
			"roo_floor TEXT NOT NULL," +
			"roo_note TEXT)";
	public static final String SQL_INSERT = "INSERT INTO rooms (roo_name, roo_floor, roo_note) VALUES(?,?,?)";
}
